package com.bhudy.enums;

/**
 * @Author com.bhudy
 * @Description 数据库关键字
 * @Date 2019-10-30 23:09:37
 */
public enum  Relation {
    //条件关系
    EQUAL(" = "),
    NOT_EQUAL(" <> "),
    GREATER_EQUAL(" >= "),
    GREATER_THAN(" > "),
    LESS_EQUAL(" <= "),
    LESS_THAN(" < "),
    IN(" in "),
    LIKE(" like "),
    IS_NULL(" is null "),
    IS_NOT_NULL(" is not null "),
    //排序关系
    ASC(" asc "),
    DESC(" desc "),
    //logic
    AND(" and "),
    OR(" or "),
    //连接
    BETWEEN(" between "),

    // 关键字
    SELECT(" select "),
    INSERT(" insert "),
    UPDATE(" update "),
    DELETE(" delete "),
    WHERE(" where "),
    SET(" set "),
    FROM(" from "),
    INTO(" into "),
    VALUES(" values "),
    AS(" as "),
    INNER(" inner "),
    JOIN(" join "),
    ON(" on "),
    LIMIT(" limit "),
    WHEN(" when "),
    THEN(" then "),
    CASE(" case "),
    END(" end ");



    private String value;

    Relation(String value) {
        this.value = value;
    }
    public String getValue() {
        return this.value;
    }
}
